package com.bigevent.mapper;

import com.bigevent.pojo.Article;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface ArticleMapper {
    //新增
    @Insert("insert into article(title,content,cover_img,state,category_id,create_user,create_time,update_time)" +
            "values(#{title},#{content},#{coverImg},#{state},#{categoryId},#{createUser},#{createTime},#{updateTime})")
    void addArticle(Article article);
    //查询文章列表 使用映射配置文件配置动态SQL查询
    List<Article> getArticleList(Integer userId, Integer categoryId, String state);
    //查询文章信息
    @Select("select * from article where id = #{id}")
    Article articleDetail(Integer id);
    //更新
    @Update("update article set title=#{title},content=#{content},cover_img=#{coverImg},state=#{state},category_id=#{categoryId},update_time=#{updateTime} where id=#{id} ")
    void updateArticle(Article article);
    //删除
    @Delete("delete from article where id=#{id}")
    void deleteArticle(Integer id);
}
